# -*- coding: utf-8 -*-
from __future__ import unicode_literals

from django.db import models, migrations


class Migration(migrations.Migration):

    dependencies = [
    ]

    operations = [
        migrations.CreateModel(
            name='Advise',
            fields=[
                ('id', models.AutoField(verbose_name='ID', primary_key=True, serialize=False, auto_created=True)),
                ('adName', models.CharField(max_length=20)),
                ('adTel', models.BigIntegerField()),
                ('adMail', models.CharField(max_length=40)),
                ('adCard', models.CharField(max_length=20)),
                ('adDate', models.DateField(auto_now=True)),
                ('adConsumerText', models.TextField(blank=True)),
                ('adSupermaketText', models.TextField(blank=True)),
                ('adMangerText', models.TextField(blank=True)),
                ('adDealSupermarket', models.DateField(blank=True)),
                ('adDealManger', models.DateField(blank=True)),
                ('adDealFinish', models.DateField(blank=True)),
                ('isDel', models.BooleanField(default=False)),
            ],
        ),
        migrations.CreateModel(
            name='BasicSensor',
            fields=[
                ('id', models.AutoField(verbose_name='ID', primary_key=True, serialize=False, auto_created=True)),
                ('sensorName', models.CharField(max_length=20)),
                ('sensorState', models.BooleanField(default=True)),
                ('sensorData', models.CharField(max_length=20)),
                ('isDel', models.BooleanField(default=False)),
            ],
        ),
        migrations.CreateModel(
            name='cInformation',
            fields=[
                ('id', models.AutoField(verbose_name='ID', primary_key=True, serialize=False, auto_created=True)),
                ('userCategory', models.CharField(max_length=20)),
                ('userCode', models.IntegerField()),
                ('userName', models.CharField(max_length=20)),
                ('userLawer', models.CharField(max_length=20)),
                ('userQualification', models.CharField(max_length=20)),
                ('userAddr', models.CharField(max_length=60)),
                ('userTel', models.BigIntegerField()),
                ('userEmail', models.CharField(max_length=20)),
                ('userPasswd', models.CharField(max_length=20)),
                ('isDel', models.BooleanField(default=False)),
            ],
        ),
        migrations.CreateModel(
            name='HardDetail',
            fields=[
                ('id', models.AutoField(verbose_name='ID', primary_key=True, serialize=False, auto_created=True)),
                ('hardCode', models.IntegerField()),
                ('boardDetail', models.CharField(max_length=40)),
                ('curState', models.BooleanField(default=True)),
                ('fixDetail', models.TextField(blank=True, null=True)),
                ('fixData', models.DateField(blank=True, null=True)),
                ('netState', models.BooleanField(default=True)),
                ('isDel', models.BooleanField(default=False)),
                ('hardLawer', models.ForeignKey(to='messageDisplay.cInformation')),
            ],
        ),
        migrations.CreateModel(
            name='ProductDetail',
            fields=[
                ('id', models.AutoField(verbose_name='ID', primary_key=True, serialize=False, auto_created=True)),
                ('proName', models.CharField(max_length=20)),
                ('proCode', models.IntegerField()),
                ('proLawer', models.CharField(max_length=20)),
                ('manAddr', models.CharField(max_length=20)),
                ('manDate', models.DateField()),
                ('expDate', models.IntegerField()),
                ('certificateText', models.CharField(max_length=20)),
                ('examiner', models.CharField(max_length=20)),
                ('isDel', models.BooleanField(default=False)),
                ('manEnterprise', models.ForeignKey(to='messageDisplay.cInformation')),
            ],
        ),
        migrations.AddField(
            model_name='basicsensor',
            name='sensorHard',
            field=models.ForeignKey(to='messageDisplay.HardDetail'),
        ),
        migrations.AddField(
            model_name='advise',
            name='adDoods',
            field=models.ForeignKey(to='messageDisplay.ProductDetail'),
        ),
    ]
